YData Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	16
Number of observations	19001
Missing cells	7531
Missing cells (%)	2.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.5 MiB
Average record size in memory	136.0 B

Variable types

Numeric	10
Text	3
Categorical	2
DateTime	1

Alerts

`host_id` is highly overall correlated with `id`	High correlation
`id` is highly overall correlated with `host_id`	High correlation
`latitude` is highly overall correlated with `neighbourhood_group`	High correlation
`longitude` is highly overall correlated with `neighbourhood_group`	High correlation
`neighbourhood_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`last_review` has 3758 (19.8%) missing values	Missing
`reviews_per_month` has 3758 (19.8%) missing values	Missing
`minimum_nights` is highly skewed (γ1 = 26.36588078)	Skewed
`id` has unique values	Unique
`number_of_reviews` has 3758 (19.8%) zeros	Zeros
`availability_365` has 6970 (36.7%) zeros	Zeros

Reproduction

Analysis started	2025-07-20 18:13:01.109645
Analysis finished	2025-07-20 18:13:08.337944
Duration	7.23 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

id
Real number (ℝ)

High correlation Unique

Distinct	19001
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18830405

Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	2539
5-th percentile	1177971
Q1	9355498
median	19387536
Q3	28919516
95-th percentile	35240782
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19564018

Descriptive statistics

Standard deviation	10969858
Coefficient of variation (CV)	0.5825609
Kurtosis	-1.2256633
Mean	18830405
Median Absolute Deviation (MAD)	9804926
Skewness	-0.066873715
Sum	3.5779653 × 10¹¹
Variance	1.2033778 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9138664	1	< 0.1%
17922181	1	< 0.1%
13746962	1	< 0.1%
20917712	1	< 0.1%
26734288	1	< 0.1%
10527546	1	< 0.1%
9518	1	< 0.1%
12188651	1	< 0.1%
28959608	1	< 0.1%
15158194	1	< 0.1%
Other values (18991)	18991	99.9%

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5803	1	< 0.1%
6090	1	< 0.1%
6848	1	< 0.1%
7750	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%
36472171	1	< 0.1%
36471896	1	< 0.1%
36468880	1	< 0.1%
36458668	1	< 0.1%
36456829	1	< 0.1%

name
Text

Distinct	18780
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	296.9 KiB

Length

Max length	179
Median length	66
Mean length	36.751395
Min length	1

Characters and Unicode

Total characters	698056
Distinct characters	504
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18619 ?
Unique (%)	98.0%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Value	Count	Frequency (%)
in	6594	5.7%
room	4014	3.5%
	3161	2.7%
bedroom	3016	2.6%
private	2874	2.5%
apartment	2658	2.3%
cozy	2017	1.7%
apt	1765	1.5%
brooklyn	1623	1.4%
studio	1556	1.3%
Other values (6673)	86285	74.7%

Most occurring characters

Value	Count	Frequency (%)
	97219	13.9%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (494)	272103	39.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	698056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	97219	13.9%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (494)	272103	39.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	698056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	97219	13.9%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (494)	272103	39.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	698056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	97219	13.9%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (494)	272103	39.0%

host_id
Real number (ℝ)

High correlation

Distinct	16241
Distinct (%)	85.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66394589

Minimum	2571
Maximum	2.7427328 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	2571
5-th percentile	764688
Q1	7728754
median	30487854
Q3	1.0483536 × 10⁸
95-th percentile	2.3951918 × 10⁸
Maximum	2.7427328 × 10⁸
Range	2.7427071 × 10⁸
Interquartile range (IQR)	97106602

Descriptive statistics

Standard deviation	77826632
Coefficient of variation (CV)	1.1721834
Kurtosis	0.28986658
Mean	66394589
Median Absolute Deviation (MAD)	27185317
Skewness	1.2459588
Sum	1.2615636 × 10¹²
Variance	6.0569847 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	117	0.6%
107434423	71	0.4%
30283594	44	0.2%
137358866	36	0.2%
12243051	36	0.2%
61391963	34	0.2%
16098958	33	0.2%
22541573	32	0.2%
26377263	24	0.1%
2856748	22	0.1%
Other values (16231)	18552	97.6%

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%
4396	1	< 0.1%
4869	1	< 0.1%
5089	1	< 0.1%
6041	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
273870123	1	< 0.1%
273841667	1	< 0.1%
273741577	1	< 0.1%
273656890	1	< 0.1%
273632292	1	< 0.1%
273619304	1	< 0.1%
273613106	1	< 0.1%

host_name
Text

Distinct	6307
Distinct (%)	33.2%
Missing	8
Missing (%)	< 0.1%
Memory size	296.9 KiB

Length

Max length	35
Median length	31
Mean length	6.1009319
Min length	1

Characters and Unicode

Total characters	115875
Distinct characters	138
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4077 ?
Unique (%)	21.5%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Value	Count	Frequency (%)
	401	1.9%
and	234	1.1%
michael	175	0.8%
david	169	0.8%
sonder	153	0.7%
john	145	0.7%
nyc	122	0.6%
alex	121	0.6%
laura	117	0.6%
maria	105	0.5%
Other values (5877)	19369	91.7%

Most occurring characters

Value	Count	Frequency (%)
a	14760	12.7%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.0%
h	3518	3.0%
Other values (128)	42579	36.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	115875	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	14760	12.7%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.0%
h	3518	3.0%
Other values (128)	42579	36.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	115875	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	14760	12.7%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.0%
h	3518	3.0%
Other values (128)	42579	36.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	115875	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	14760	12.7%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.0%
h	3518	3.0%
Other values (128)	42579	36.7%

neighbourhood_group
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	296.9 KiB

Brooklyn	8046
Manhattan	8031
Queens	2331
Bronx	434
Staten Island	159

Length

Max length	13
Median length	9
Mean length	8.1506237
Min length	5

Characters and Unicode

Total characters	154870
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Brooklyn	8046	42.3%
Manhattan	8031	42.3%
Queens	2331	12.3%
Bronx	434	2.3%
Staten Island	159	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brooklyn	8046	42.0%
manhattan	8031	41.9%
queens	2331	12.2%
bronx	434	2.3%
staten	159	0.8%
island	159	0.8%

Most occurring characters

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
r	8480	5.5%
B	8480	5.5%
l	8205	5.3%
y	8046	5.2%
k	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	154870	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
r	8480	5.5%
B	8480	5.5%
l	8205	5.3%
y	8046	5.2%
k	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	154870	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
r	8480	5.5%
B	8480	5.5%
l	8205	5.3%
y	8046	5.2%
k	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	154870	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
r	8480	5.5%
B	8480	5.5%
l	8205	5.3%
y	8046	5.2%
k	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

neighbourhood
Text

Distinct	215
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	296.9 KiB

Length

Max length	26
Median length	17
Mean length	11.919478
Min length	4

Characters and Unicode

Total characters	226482
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Value	Count	Frequency (%)
east	2575	8.4%
side	1756	5.7%
harlem	1540	5.0%
williamsburg	1526	5.0%
bedford-stuyvesant	1478	4.8%
heights	1427	4.7%
upper	1401	4.6%
village	1186	3.9%
west	1033	3.4%
bushwick	978	3.2%
Other values (227)	15760	51.4%

Most occurring characters

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	226482	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	226482	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	226482	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

latitude
Real number (ℝ)

High correlation

Distinct	12087
Distinct (%)	63.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.728063

Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.64456
Q1	40.68882
median	40.72171
Q3	40.76321
95-th percentile	40.82645
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07439

Descriptive statistics

Standard deviation	0.05538931
Coefficient of variation (CV)	0.001359979
Kurtosis	0.05864488
Mean	40.728063
Median Absolute Deviation (MAD)	0.03659
Skewness	0.2542518
Sum	773873.93
Variance	0.0030679757
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71813	8	< 0.1%
40.72232	8	< 0.1%
40.68634	8	< 0.1%
40.69414	8	< 0.1%
40.68683	7	< 0.1%
40.72607	7	< 0.1%
40.68084	7	< 0.1%
40.72434	6	< 0.1%
40.76389	6	< 0.1%
40.70741	6	< 0.1%
Other values (12077)	18930	99.6%

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53871	1	< 0.1%
40.53939	1	< 0.1%
40.54106	1	< 0.1%
40.54312	1	< 0.1%
40.5455	1	< 0.1%
40.54857	1	< 0.1%
40.54889	1	< 0.1%
40.54901	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.90281	1	< 0.1%
40.9026	1	< 0.1%
40.89981	1	< 0.1%
40.89811	1	< 0.1%
40.89756	1	< 0.1%

longitude
Real number (ℝ)

High correlation

Distinct	9944
Distinct (%)	52.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.950827

Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Negative	19001
Negative (%)	100.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.00369
Q1	-73.98205
median	-73.95463
Q3	-73.93449
95-th percentile	-73.86186
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04756

Descriptive statistics

Standard deviation	0.046824987
Coefficient of variation (CV)	-0.00063319085
Kurtosis	4.8242797
Mean	-73.950827
Median Absolute Deviation (MAD)	0.02489
Skewness	1.2340208
Sum	-1405139.7
Variance	0.0021925794
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.94829	9	< 0.1%
-73.95725	9	< 0.1%
-73.95121	9	< 0.1%
-73.95742	9	< 0.1%
-73.95427	9	< 0.1%
-73.98589	9	< 0.1%
-73.95675	8	< 0.1%
-73.9567	8	< 0.1%
-73.95149	8	< 0.1%
-73.98043	8	< 0.1%
Other values (9934)	18915	99.5%

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17628	1	< 0.1%
-74.17388	1	< 0.1%
-74.17117	1	< 0.1%
-74.17065	1	< 0.1%
-74.16966	1	< 0.1%
-74.16634	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%
-73.7274	1	< 0.1%
-73.72778	1	< 0.1%
-73.72817	1	< 0.1%
-73.72901	1	< 0.1%
-73.72928	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	296.9 KiB

Entire home/apt	9522
Private room	9041
Shared room	438

Length

Max length	15
Median length	15
Mean length	13.480343
Min length	11

Characters and Unicode

Total characters	256140
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	9522	50.1%
Private room	9041	47.6%
Shared room	438	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	9522	25.1%
home/apt	9522	25.1%
room	9479	24.9%
private	9041	23.8%
shared	438	1.2%

Most occurring characters

Value	Count	Frequency (%)
e	28523	11.1%
o	28480	11.1%
r	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
p	9522	3.7%
Other values (7)	47524	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	256140	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	28523	11.1%
o	28480	11.1%
r	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
p	9522	3.7%
Other values (7)	47524	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	256140	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	28523	11.1%
o	28480	11.1%
r	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
p	9522	3.7%
Other values (7)	47524	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	256140	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	28523	11.1%
o	28480	11.1%
r	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
p	9522	3.7%
Other values (7)	47524	18.6%

price
Real number (ℝ)

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.34046

Minimum	10
Maximum	350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	10
5-th percentile	40
Q1	66
median	100
Q3	160
95-th percentile	270
Maximum	350
Range	340
Interquartile range (IQR)	94

Descriptive statistics

Standard deviation	71.530346
Coefficient of variation (CV)	0.58468268
Kurtosis	0.50280069
Mean	122.34046
Median Absolute Deviation (MAD)	45
Skewness	1.0270244
Sum	2324591
Variance	5116.5903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.5%
150	821	4.3%
50	636	3.3%
200	590	3.1%
75	570	3.0%
60	555	2.9%
80	531	2.8%
70	482	2.5%
120	471	2.5%
65	471	2.5%
Other values (311)	13018	68.5%

Value	Count	Frequency (%)
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	3	< 0.1%
18	1	< 0.1%
19	3	< 0.1%
20	13	0.1%
21	3	< 0.1%

Value	Count	Frequency (%)
350	147	0.8%
349	14	0.1%
348	1	< 0.1%
347	2	< 0.1%
346	1	< 0.1%
345	11	0.1%
344	1	< 0.1%
343	2	< 0.1%
342	1	< 0.1%
341	2	< 0.1%

minimum_nights
Real number (ℝ)

Skewed

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.9068996

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	21.456544
Coefficient of variation (CV)	3.1065377
Kurtosis	1156.4552
Mean	6.9068996
Median Absolute Deviation (MAD)	1
Skewness	26.365881
Sum	131238
Variance	460.38328
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5003	26.3%
2	4619	24.3%
3	3086	16.2%
30	1442	7.6%
4	1253	6.6%
5	1140	6.0%
7	822	4.3%
6	285	1.5%
14	210	1.1%
10	178	0.9%
Other values (65)	963	5.1%

Value	Count	Frequency (%)
1	5003	26.3%
2	4619	24.3%
3	3086	16.2%
4	1253	6.6%
5	1140	6.0%
6	285	1.5%
7	822	4.3%
8	52	0.3%
9	34	0.2%
10	178	0.9%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
480	1	< 0.1%
400	1	< 0.1%
370	1	< 0.1%
365	11	0.1%
364	1	< 0.1%
300	1	< 0.1%
299	1	< 0.1%
240	2	< 0.1%

number_of_reviews
Real number (ℝ)

High correlation Zeros

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.797747

Minimum	0
Maximum	607
Zeros	3758
Zeros (%)	19.8%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	24
95-th percentile	116
Maximum	607
Range	607
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	45.493455
Coefficient of variation (CV)	1.9116706
Kurtosis	19.565921
Mean	23.797747
Median Absolute Deviation (MAD)	6
Skewness	3.7060188
Sum	452181
Variance	2069.6544
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%
5	589	3.1%
6	544	2.9%
7	495	2.6%
8	449	2.4%
9	383	2.0%
Other values (311)	7648	40.3%

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%
5	589	3.1%
6	544	2.9%
7	495	2.6%
8	449	2.4%
9	383	2.0%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%
467	1	< 0.1%
466	1	< 0.1%
459	1	< 0.1%
448	1	< 0.1%
441	1	< 0.1%

last_review
Date

Missing

Distinct	1494
Distinct (%)	9.8%
Missing	3758
Missing (%)	19.8%
Memory size	296.9 KiB

Minimum	2011-05-12 00:00:00
Maximum	2019-07-08 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

High correlation Missing

Distinct	789
Distinct (%)	5.2%
Missing	3758
Missing (%)	19.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.3809276

Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.69
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.6899884
Coefficient of variation (CV)	1.2238066
Kurtosis	11.9516
Mean	1.3809276
Median Absolute Deviation (MAD)	0.62
Skewness	2.4353306
Sum	21049.48
Variance	2.8560608
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	362	1.9%
1	352	1.9%
0.05	333	1.8%
0.03	323	1.7%
0.04	268	1.4%
0.08	256	1.3%
0.16	244	1.3%
0.09	235	1.2%
0.06	226	1.2%
0.11	217	1.1%
Other values (779)	12427	65.4%
(Missing)	3758	19.8%

Value	Count	Frequency (%)
0.01	17	0.1%
0.02	362	1.9%
0.03	323	1.7%
0.04	268	1.4%
0.05	333	1.8%
0.06	226	1.2%
0.07	168	0.9%
0.08	256	1.3%
0.09	235	1.2%
0.1	191	1.0%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%
13.45	1	< 0.1%
13.42	1	< 0.1%
13.24	1	< 0.1%
13.15	1	< 0.1%
12.99	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5838114

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	13
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	31.15475
Coefficient of variation (CV)	4.7320235
Kurtosis	77.214814
Mean	6.5838114
Median Absolute Deviation (MAD)	0
Skewness	8.4612229
Sum	125099
Variance	970.61846
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%
6	208	1.1%
7	165	0.9%
8	164	0.9%
327	117	0.6%
9	98	0.5%
Other values (37)	1010	5.3%

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%
6	208	1.1%
7	165	0.9%
8	164	0.9%
9	98	0.5%
10	69	0.4%

Value	Count	Frequency (%)
327	117	0.6%
232	71	0.4%
121	44	0.2%
103	36	0.2%
96	69	0.4%
91	34	0.2%
87	32	0.2%
65	19	0.1%
52	41	0.2%
50	16	0.1%

availability_365
Real number (ℝ)

Zeros

Distinct	366
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	109.72538

Minimum	0
Maximum	365
Zeros	6970
Zeros (%)	36.7%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	39
Q3	219
95-th percentile	358
Maximum	365
Range	365
Interquartile range (IQR)	219

Descriptive statistics

Standard deviation	130.5999
Coefficient of variation (CV)	1.1902433
Kurtosis	-0.93482914
Mean	109.72538
Median Absolute Deviation (MAD)	39
Skewness	0.80270185
Sum	2084892
Variance	17056.334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6970	36.7%
365	432	2.3%
364	195	1.0%
1	176	0.9%
5	133	0.7%
3	115	0.6%
2	113	0.6%
179	112	0.6%
89	111	0.6%
6	110	0.6%
Other values (356)	10534	55.4%

Value	Count	Frequency (%)
0	6970	36.7%
1	176	0.9%
2	113	0.6%
3	115	0.6%
4	107	0.6%
5	133	0.7%
6	110	0.6%
7	96	0.5%
8	85	0.4%
9	83	0.4%

Value	Count	Frequency (%)
365	432	2.3%
364	195	1.0%
363	88	0.5%
362	62	0.3%
361	44	0.2%
360	33	0.2%
359	49	0.3%
358	53	0.3%
357	33	0.2%
356	26	0.1%

	availability_365	calculated_host_listings_count	host_id	id	latitude	longitude	minimum_nights	neighbourhood_group	number_of_reviews	price	reviews_per_month	room_type
availability_365	1.000	0.411	0.164	0.157	-0.020	0.080	0.078	0.079	0.257	0.059	0.397	0.093
calculated_host_listings_count	0.411	1.000	0.142	0.136	-0.002	0.068	0.063	0.085	0.066	-0.118	0.153	0.094
host_id	0.164	0.142	1.000	0.552	0.035	0.123	-0.147	0.102	-0.114	-0.102	0.271	0.099
id	0.157	0.136	0.552	1.000	-0.008	0.080	-0.073	0.060	-0.302	-0.046	0.365	0.073
latitude	-0.020	-0.002	0.035	-0.008	1.000	0.048	0.016	0.537	-0.032	0.132	-0.030	0.104
longitude	0.080	0.068	0.123	0.080	0.048	1.000	-0.123	0.647	0.072	-0.418	0.127	0.142
minimum_nights	0.078	0.063	-0.147	-0.073	0.016	-0.123	1.000	0.000	-0.164	0.106	-0.292	0.021
neighbourhood_group	0.079	0.085	0.102	0.060	0.537	0.647	0.000	1.000	0.026	0.181	0.067	0.115
number_of_reviews	0.257	0.066	-0.114	-0.302	-0.032	0.072	-0.164	0.026	1.000	-0.020	0.707	0.000
price	0.059	-0.118	-0.102	-0.046	0.132	-0.418	0.106	0.181	-0.020	1.000	-0.020	0.497
reviews_per_month	0.397	0.153	0.271	0.365	-0.030	0.127	-0.292	0.067	0.707	-0.020	1.000	0.016
room_type	0.093	0.094	0.099	0.073	0.104	0.142	0.021	0.115	0.000	0.497	0.016	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaT	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaT	NaN	1	0
19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample